Format Layout Tab
The Format Layout tab lets you define the column name, column width, and some behavioral options for the report results. The column heading names on the report are defined in the Display Label column. In the illustration below, the document name will be displayed as Title, and the document code will be displayed as Number.
The Width column lets you specify the number of pixels to use in displaying the column. If you want equal size columns then leave the asterisk * in each of the Width columns. If you specify a width (pixel value) for some of the columns and use the asterisk for the rest of the columns, space is first allocated for the specified widths, and then the remainder is divided evenly among the columns with an asterisk.
The order of rows in the Format Layout Tab determines the order of columns in the final report. If you wish to change the row order, select the Search Alias cell and then drag/drop the row to the desired position.
Displaying Hyperlinks in Report Results
The Format Layout tab also lets you designate certain columns as hyperlinks that will open the specified object in the content pane. This tab also lets you specify that if the user double-clicks on the row itself, the specified object will open in the content pane.
In order for an object to be hyperlinked, its internal id must be included in the SELECT clause specified in the Define Search tab. The eQL id can be from the primary object or a secondary object related to the primary object, and you can include more than one id in the SELECT clause. For example, if you are building a document report and want hyperlinks for the documents in the report and also for persons related to each document, you can include Id and the Persons.Person.Id in the SELECT clause.
Including ids in the SELECT clause causes them to display as rows in the Format Layout tab. These ids are then available for selection in the areas labeled Properties for column name and Properties for the Report, which is where you specify the hyperlink behavior.
Use the Properties for the Report fields to make a document row open when a user double-clicks it, and use the Properties for the column <Name> fields to make a column entry a hyperlink.
The Display as Hyperlink check box lets you define an eQL element to be a hyperlink to an object that is not the START WITH object. For example, if you want hyperlinks for documents in a report and also for persons related to each document, the eQL elements Id and Persons.Person.Id need to be included in the SELECT clause on the Define Search tab. See the following procedures to see how this can be accomplished.